The Table Wizard creates a new table to store data. Select a sample table, then select the sample field you want and click the > button. The fields you select become columns in your new table.up to 3 fields.)
The Table Wizard creates a new table to store data.
Select a sample table, then select the sample field you want and click the > button. The fields you select become columns in your new table.
qHow would you like to sort the data in your new table?
Each field you select will become a separate index tag.
:Your table is finished!
What would you like to do next?
What would you like to do now?
}Select and add the fields you want in your new table.
Click Rename Field... to rename a field in the Selected Fields list.
Which fields do you want to use to sort the records?
Select each field you want to sort on and click the Add button. (Select up to 3 fields.)
Using the Table list below, select and add the fields you want in your new table.
Click Rename Field... to rename a field in the Selected Fields list.
By which fields do you want to sort the records?
Select each field you want to sort by and click the Add button. (Select up to 3 fields.)
(Select an option below and click Finish.
Using the Table list below, select and add the fields you want in your new table.
Click Change Field... to change the attributes of a field in the Selected Fields list.
Using the Table list below, select and add the fields you want in your new table.
Click Modify Field... to change the attributes of a field in the Selected Fields list.[eefFPvv[[[FF
Using the lists below, select and add the fields you want in your new table.
Click Modify Field... to change the attributes of a field in the Selected Fields list. list.
WIZ_TBL1
WIZ_SCRN
wiz_tbl1.spr
SCRNFILE
WZSBMPFILEBMPFILE
WZIPREVSTECLREGN
GETTABLES
GETFIELDS
WIZ_TBL1
wzt_tbls
TABLENAME
TABLEID
WZT_TBLS
WZAT_TBL
EWZIT_TBL
wzt_tfld
wzt_flds
wzt_ftyp
WIZ_SCRN
wzat_fld
ENAME
WZIT_TBL
FNAME
IT_TBL
FIELDNAME
TFIELDS
DATATYPE
FIELDSIZE
DECIMALPLAWZT_TFLD
WZT_FLDS
WZT_FTYP
TABLEID
WZAT_TBL
FIELDID
FIELDTYPEIWZAT_FLD
ISORTORDER
WZAFSTART
WZIT_FLD
CHECKFIELDSHOWFIELD
wzat_fld
wzaNewFld
wzaNewFld
wzat_fld8
wzat_fld
wzaNewFld
wzaNewFld
wzaNewFld
wzaNewFld
wzat_fld
wzaNewFld
wzat_fld
wzaNewFld
wzat_fld
wzaNewFld8
wzat_fld
wzat_fld
WZIBTN
LISTLEN
DUPEALERT
MAXALERT
WZIT_FLD
WZAT_FLD
WZLOKMOVE
MOVEITEM
WZINEWFLD
LISTFOCUS
WZANEWFLD
FLDSEARCH
WZAFSTART
LISTPOS
NEWFLDWHENSHOWFIELD
SHOWBTNS
WZSFLDNAMEWZINEWFLD
WZANEWFLD
if m.wziarrpos > 0 and ! empty(&wzsarrname[m.wziarrpos,2])
@ 9,21 GET m.wzit_fld PICTURE "@&N" FROM wzat_fld SIZE 7,17 DEFAULT 1 WHEN !EMPTY(wzat_fld[1]) and ShowField("wzat_fld", m.wzit_fld) VALID MoveFld(1) COLOR SCHEME 16
@*VN
@*VN
@*VN
@*VN
@*HN Modify Field...
@ 9,48 GET m.wziNewFld PICTURE "@&N" FROM wzaNewFld SIZE 7,17 DEFAULT 1 WHEN !EMPTY(wzaNewFld[1]) and NewFldWhen() and ShowField("wzaNewFld", m.wziNewFld) VALID MoveFld(3) COLOR SCHEME 16
wiz_btns.spr
@ 9,2 GET m.wzit_tbl PICTURE "@&N" FROM wzat_tbl SIZE 7,17 DEFAULT 1 WHEN _qnr0kmj7i() VALID _qnr0kmj7y() COLOR SCHEME 16
wiz_scrn
wiz_scrn
TALKz
COMPATIBLEz
READBORDERz
wiz_scrn
WIZ_SCRN
WIZ_SCRN.PJX
WIZ_SCRN
WIZ_SCRN.SCX
WIZ_SCRN
WIZ_SCRN.MNX
WIZ_SCRN
WIZ_SCRN.PRG
WIZ_SCRN
WIZ_SCRN.FRX
WIZ_SCRN
WIZ_SCRN.QPR
MS Sans Serif
wiz_line.spr
wiz_pic.spr
wiz_obj.spr
wiz_scrn
Fields:
MS Sans Serif
MS Sans Serif
MS Sans Serif
|?U1@
@ 12.154,2.400 GET m.wzit_tbl PICTURE "@&N" FROM wzat_tbl SIZE 5.769,21.400 DEFAULT 1 FONT "MS Sans Serif", 8 WHEN _qnr0kmjxg() VALID _qnr0kmjxt()
@ 12.154,26.600 GET m.wzit_fld PICTURE "@&N" FROM wzat_fld SIZE 5.769,21.400 DEFAULT 1 FONT "MS Sans Serif", 8 WHEN !EMPTY(wzat_fld[1]) and ShowField("wzat_fld", m.wzit_fld) VALID MoveFld(1)
MS Sans Serif
@*VN >
MS Sans Serif
@*VN >>
MS Sans Serif
@*VN <
MS Sans Serif
@*VN <<
MS Sans Serif
@*HN \<Modify Field...
@ 13.231,59.000 GET wziNewFld PICTURE "@&N" FROM wzaNewFld SIZE 4.615,21.400 DEFAULT 1 FONT "MS Sans Serif", 8 WHEN !EMPTY(wzaNewFld[1]) and NewFldWhen() and ShowField("wzaNewFld", m.wziNewFld) VALID MoveFld(3)
1FirstName First Name 3 2LastName Last Name 4 3MidName Middle Name 2 4Address Address 7 5City City 5 6State State 1 8Country Country 3 10WorkPhone Work Phone 4 11Fax Fax Number 4 34Title Title 3 68RecLabel Recording Label 4 71SalePrice Sale Price 10 72DatePurch Date Purchased 14 73DateSold Date Sold 14 75NumServingNumber of Servings 8 77Director Director 4 80LeadActor Leading Actor 4 81Producer Producer 4 82Genus Genus 5 83Species Species 5 84CommName Common Name 5 86LightPref Light Preference 2 87WaterFreq Watering Frequency 2 89DatePlant Date Planted 14 90DateFert Date Fertilized 14 104LastMeet Last Meeting Date 14 105WorkoutDatWorkout Date 14 118WhichMeal Which Meal 2 129DateTaken Date Taken 14 132ShutterSpdShutter Speed 2 133Aperture Aperture 2 134PlaceTakenPlace Taken 6 135SubjName Subject Name 5 136SubjAddr Subject Address 7 137SubjPhone Subject Phone 4 139PostalCodePostal Code 2 144ContactID Contact ID 3 148BookCollIDBook Collection ID 3 149PlantID Plant ID 3 151HouseInvIDHousehold Inventory 12 153VideoColIDVideo Collection ID 3 154OrderID Order ID 3 156EventID Event ID 3 157ReservID Reservation ID 3 167DietLogID Diet Log ID 3 169PhotoID Photograph ID 3 176DateHired Date Hired 14 180EventName Event Name 5 192ShipVia Ship Via 3 193RequiredByRequired By Date 14 196TempPref Temperature Preference 3 202QtyReserveQuantity Reserved 9 203Confirmed Confirmed 13 207LdgActressLeading Actress 4 210Rating Rating 8 223Format Format 3 229YearRelsd Year Released 16 235OrgName Organization Name 5 245HoursSinceHours Since Last Service 9 246MilesSinceMiles Since Last Service 9 249NextServ Next Scheduled Service 14 250Model Model 4 253DescProb Description of Problem 12 324Quantity Quantity 9 337Manufact Manufacturer 5 338SupplierIDSupplier ID 3 346ShipName Ship Name 5 347ShipAddr Ship Address 6 348ShipCity Ship City 3 349ShipState Ship State 1 350ShipPostalShip Postal Code 2 351ShipCtry Ship Country 3 352OrderDate Order Date 14 353ShipDate Ship Date 14 356Discount Discount 8 358SalesTax Sales Tax 10 359FreightChgFreight Charge 10 362PymtTerms Payment Terms 4 396DestCity Destination City 4 413ContName Contact Name 4 466FilmExpDatFilm Expiration Date 14 467FilmType Film Type 2 468ColorFilm Color Film 13 564AuthorID Author ID 3 566Birthdate Birthdate 14 567BirthplaceBirthplace 5 568DateDeath Date of Death 14 569TrainLoc Training Location 5 691MovieTitleMovie Title 5 751TimeBilledTime Billed ID 3 866PickUpLocaPick Up Location 5 868PickupDatePickup DateTime 5 869PkgCurLocaPackage Current Location 5 870PkgWeight Package Weight 8 960PubName Publisher Name 5 968Note Note 12 980EmailName Email Name 4 981EmailAddr Email Address 5 988Nickname Nickname 3 995Region Region 3 1004Descript Description 12 1059PurchPricePurchase Price 10 1084RecipeID Recipe ID 3 1085IngredientIngredients 12 1096RecipeDescRecipe Description 12 1105Pages Pages 8 1112ShelfNum Shelf Number 8 1119DeptName Department Name 4 1121SupervisorSupervisor ID 3 1122EmployeeIDEmployee ID 3 1128Suffix Suffix 2 1151AccountNumAccount Number 3 1176PymtDate Payment Date 14 1179CheckNum Check Number 8 1184SocialSec Social Security Number 3 1208Comments Comments 12 1292AvailSpaceAvailable Spaces 8 1305ProjTmMembProject Team Members 12 1435ExerLogID Exercise Log ID 3 1436CalsBurnedCalories Burned 8 1438AeroAnaeroAerobic Or Anaerobic 2 1439DistTravelDistance Traveled 9 1441Activity Activity 5 1457HoursSleepHours Sleep 8 1461RestPulse Resting Pulse 8 1462MaxPulse Maximum Pulse 8 1510InDatTime Checkin DateTime 4 1511OutDatTimeCheckout DateTime 4 1544ServRecID Service Record ID 3 1549Review Review 12 1558PhoneNum Phone Number 3 1579CustomerIDCustomer ID 3 1581ProductID Product ID 3 1648PaymentID Payment ID 3 1882OrderDetIDOrder Detail ID 3 1941DeliveryIDDelivery ID 3 1942InvestmentInvestment ID 3 1967AccountID Account ID 3 2003TransactIDTransaction ID 3 2025AcctName Account Name 5 2075ApprValue Appraised Value 10 2126ProdName Product Name 4 2142ShipRegionShip Region 3 2144Extension Extension 16 2145PhotographPhotograph 15 2146ContTitle Contact Title 3 2149UnitPrice Unit Price 10 2150UnInStock Units In Stock 9 2151UnOnOrder Units On Order 9 2153ReorderLvlReorder Level 9 2154Discontd Discontinued 13 2156MajorInfluMajor Influences 12 2159Prefix Prefix 3 2161ArrDatTimeArrival DateTime 4 2163Subject Subject 6 2164CoverType Cover Type 3 2165EditionNumEdition Number 8 2170ItemType Item Type 3 2172SerialNum Serial Number 5 2173MusCollID Music Collection ID 3 2175Room Room 8 2176DatAcqRec Date Acquired or Received 14 2177DateErasedDate Tape Last Erased 14 2178Length Length 10 2181InvoiceID Invoice ID 3 2186ExpenseID Expense ID 3 2190MailListIDMailing List ID 3 2192ServDate Service Date 14 2193PvServDatePrevious Service Date 14 2196DescServ Description of Service 12 2197ActualCostActual Cost 10 2198EstdCost Estimated Cost 10 2199Make Make 4 2201DateProm Date Promised 14 2202DepositAmtDeposit Amount 11 2203ReceivedByReceived By 4 2204AuthorizedAuthorized By 4 2205PartsRepl Parts Replaced 12 2206LaborHoursLabor Hours Estimate 10 2207DateJoinedDate Joined 14 2208SpouseNameSpouse Name 4 2209Hobbies Hobbies 6 2210MembershipMembership Status 3 2211HealthProbHealth Problems 12 2212EmerName Emergency Contact Name 4 2214EmerPhone Emergency Contact Phone 4 2231PymtMethodPayment Method 3 2239HourlyRateHourly Rate 17 2255DescExpensDescription of Expense 12 2256ExpensTypeExpense Type 4 2257AmtSpent Amount Spent 10 2258AdvAmount Advance Amount 10 2259DateSubmitDate Submitted 14 2260PurposeExpPurpose of Expense 6 2261InstrExp Instructions for Expense 12 2263Flowering Flowering 13 2264FertFreq Fertilization Frequency 4 2268CardName Credit Card Name 4 2269CardExpireCredit Card Expire Date 14 2270CardNumberCredit Card Number 4 2271PymtAmountPayment Amount 10 2273Vitamins Vitamins 5 2278DietType Diet Type 4 2279TotalCalorTotal Calories 8 2280GramsFat Grams Fat 17 2281GramsCarboGrams Carbohydrates 17 2282GramsProt Grams Protein 17 2283MilligramsMilligrams Sodium 8 2285ShippedTo Shipped To 5 2287Salespers Salesperson Name 4 2288PriceUnit Price Per Unit 17 2290ShippedViaShipped Via 4 2293ShipCost Shipping Cost 10 2296PurchAt Purchased At 4 2302ProjName Project Name 4 2304NumBillHrsNumber of Billable Hours 17 2306ProjDesc Project Description 12 2311ReferredByReferred By 4 2319MobilPhoneMobile Phone 4 2321EventType Event Type 3 2322Location Location 5 2325CostPersonCost Per Person 10 2327StartTime Start Time 3 2328EndTime End Time 3 2340PkgDimen Package Dimensions 3 2344ShipFrom Shipped From 4 2345FixedAssetFixed Asset ID 3 2346AssetName Asset Name 5 2348BeginValueBeginning Value 10 2349CurrentValCurrent Value 10 2350DeprMethodDepreciation Method 3 2351DeprRate Depreciation Rate 8 2356AcctType Account Type 4 2357CatName Category Name 5 2361Action Action 4 2362SecName Security Name 4 2364PSPrice Purchase or Sell Price 10 2365SharesOwn Shares Owned 8 2366Clear Clear 13 2367SecSymbol Security Symbol 16 2368SecType Security Type 4 2369TransDate Transaction Date 14 2370RefNumber Reference Number 4 2374TransNum Transaction Number 8 2376ServChargeService Charge 10 2377IntEarned Interest Earned 10 2795CatType Category Type 3 2796CategoryIDCategory ID 3 2797NationalitNationality 3 2798CopyrDate Copyright Date 14 2805DestState Destination State 1 2806DestPostalDestination Postal Code 2 2809PlacePurchPlace Purchased 4 2815PromisedByPromised By Date 14 2819Camera Camera 4 2820Flash Flash 13 2821FilterUsedFilter Used 3 2822LensUsed Lens Used 3 2823DateDevel Date Developed 14 2824DevelopBy Developed By 4 2825PrintSize Print Size 3 2827DatePrunedDate Pruned 14 2828DateRepottDate Repotted 14 2829CalsServ Calories Per Serving 8 2830NutritInfoNutritional Information 12 2831Source Source 4 2832TimeToPrepTime To Prepare 4 2833VegetarianVegetarian 13 2835BillDate Billing Date 14 2836PurchRec Purchased Or Recorded 2 2839TimeTaken Time Taken 4 2840ArtistID Artist ID 3 2841ActItems Action Items 12 2842PersonID Person ID 3 2843TimeExer Time Exercised 4 2844ExerType Exercise Type 3 2845ModelNum Model Number 4 2846Insured Insured 13 2847InvDetID Invoice Detail ID 3 2849DateUpdateDate Updated 14 2851AltPhone Alternative Phone 4 2852CISID CompuServe ID 3 2853DuesAmountDues Amount 10 2854DuesPdDateDues Paid Date 14 2855PledgeAmt Pledge Amount 10 2856PlgPdDate Pledge Paid Date 14 2857CardType Credit Card Type 3 2859DepositDueDeposit Due 10 2860TotalDue Total Due 10 2861AmountPaidAmount Paid 10 2862ProjectID Project ID 3 2863Taxable Taxable 13 2864DateRecordDate Recorded 14 2865InvDate Invoice Date 14 2866PurSelDatePurchase or Sell Date 14 2868HomePhone Home Phone 4 2872FilmID Film ID 3 2873ReservDateReservation Date 14 2875ISBNNumberISBN Number 3 2876ProjLead Project Lead 4 2879ContactTypContact Type 3 2886LaborHrActLabor Hours Actual 8 2895GroupName Group Name 4 2897Vintage Vintage 6 2898CtryOriginCountry Of Origin 4 2899Variety Variety 4 2900Color Color 3 2902Vineyard Vineyard 4 2903WineListIDWine List ID 3 2904PctAlcoholPercent Alcohol 17 2906WineType Wine Type 3 2907SweetOrDrySweet Or Dry 2 2908ServInstr Serving Instructions 12 2909QtyOnHand Quantity On Hand 8 2911NumTracks Number of Tracks 8 2912StudentID Student ID 3 2913ClassID Class ID 3 2914TaskID Task ID 3 2915Major Major 4 2916ClassName Class Name 5 2917SecNumber Section Number 3 2918Term Term 3 2919Year Year 16 2921DeptNumberDepartment Number 3 2922InstructorInstructor 4 2923Units Units 8 2924TaskDesc Task Description 12 2925StartDate Start Date 14 2926EndDate End Date 14 2927Grade Grade 2 2930DestAddr Destination Address 6 2931DestCtry Destination Country 4 2932NtlEmpNum National Employee Number 5 2933WineName Wine Name 4 2934ItemName Item Name 4 2935Type Type 3 2936Status Status 2 2940SamSndClipSample Sound Clip 15 2944ParentNameParents Names 5 2946DateWater Date Watered 14 2947RecipeNameRecipe Name 4 2949FilmSpeed Film Speed 2 2950DateDeliv Date Delivered 14 2952ShipTrCodeShipper Tracking Code 3 2953ShipPhone Shipper Phone Number 4 2955SamVidClipSample Video Clip 15 2956ChildNamesChildren Names 5 2958LastTalkedDate Last Talked To 14 2959PlaceStay Place Staying 4 2960CheckedIn Checked In 13 2961GiftGiven Gift Given 4 2962ThanksSentThankyou Note Sent 13 2963NumAttend Number Attending 8 2964NeedDaycarNeed Daycare 13 2965FriendID Friend ID 3 2966GuestID Guest ID 3 2967RoomNum Room Number 8 2968SupplName Supplier Name 4 2969EmplTaskIDEmployee And Task ID 3 2970StuClassIDStudent And Class ID 3
(.txt)